package manong.mapper;

import com.github.pagehelper.PageInfo;
import manong.beans.Score;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.session.RowBounds;

	import java.util.List;
	@Mapper
	public interface ScoreMapper {


		@Select("select * from score")
		List<Score> findAll();

		List<Score> findBy(@Param("sno") Integer sno, @Param("className")String className, @Param("courseName")String courseName);

		@Delete("delete from score where id = #{id}")
		Integer deleteByPrimaryKey(Integer id);

		@Insert("insert into score(sno,stu_name,score,course_name,class_id,course_id,seme_name,class_name) values(#{sno},#{stu_name},#{score},#{course_name},#{class_id},#{course_id},#{seme_name},#{class_name})")
        Integer insert(Score scoreObject);

		@Select("select * from score where id = #{id}")
		Score selectByPrimaryKey(Integer id);

		int update(Score scoreObj);

		@Select("select * from score where sno = #{sno} ")
		List<Score> findByStu(String sno);
	}
